﻿CREATE TABLE [dbo].[Users] (
    [UserId]               UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [MembershipUserId]     UNIQUEIDENTIFIER NULL,
    [FirstName]            NVARCHAR (50)    NULL,
    [LastName]             NVARCHAR (50)    NULL,
    [CompanyName]          NVARCHAR (200)   NULL,
    [FirstSurname]         NVARCHAR (50)    NULL,
    [LastSurname]          NVARCHAR (50)    NULL,
    [FullName]             NVARCHAR (200)   NULL,
    [BirthDate]            DATETIME         NULL,
    [NacionalityCountryId] UNIQUEIDENTIFIER NULL,
    [IsEnabled]            BIT              NOT NULL,
    [IsLocked]             BIT              NOT NULL,
    [PinNumber]            NVARCHAR (10)    NOT NULL,
    [BranchId]             UNIQUEIDENTIFIER NULL,
    [UserType]             NVARCHAR (50)    NOT NULL,
    [Activity]             NVARCHAR (200)   NULL,
    [GenderId]             UNIQUEIDENTIFIER NULL,
    [MaritalStatusId]      UNIQUEIDENTIFIER NULL
);



